--------------------------------------------------------
--  DDL for Trigger REPORT_FIELDS_PK_TRG
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "REPORT_FIELDS_PK_TRG" 
  BEFORE INSERT ON "REPORT_FIELDS"
  REFERENCING FOR EACH ROW
  begin  
   if inserting then 
      if :NEW."RFID" is null then 
         select FIELD_SEQ.nextval into :NEW."RFID" from dual; 
      end if; 
   end if; 
end;
ALTER TRIGGER "REPORT_FIELDS_PK_TRG" ENABLE
